<?php require_once('Select_town/Connections/connection.php'); ?>
<?php
mysql_select_db($database_connection, $connection);
$query_rs_town = "SELECT * FROM tbl_town ORDER BY town_name ASC";
$rs_town = mysql_query($query_rs_town, $connection) or die(mysql_error());
?>
 

<!-- show clinic in beauty clinic -->
<?
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("database");
mysql_query("SET NAMES UTF8");

if($_GET["Action"] == "Save")
{
	//*** Insert Reply ***//
	$strSQL = "INSERT INTO clinic_ment ";
	$strSQL .="(clinic_id,CreateDate,Time,Details,Name) ";
	$strSQL .="VALUES ";
	$strSQL .="('".$_GET["clinic_id"]."','".date("Y-m-d H:i:s")."','".date("Y-m-d H:i:s")."','".$_POST["txtDetails"]."','".$_POST["name"]."' ) ";
	$objQuery = mysql_query($strSQL);

	//*** Update Reply ***//
	$strSQL = "UPDATE clinic";
	$strSQL .="SET Ment = Ment + 1 WHERE clinic_id = '".$_GET["clinic_id"]."' ";
	$objQuery = mysql_query($strSQL);	
	echo "<meta http-equiv ='refresh'content='0;URL=./clinicshow.php?clinic_id=".$_GET["clinic_id"]." '>";
 }
 
if($_GET["Action"] == "Delete")
{	
 	$strSQL =  "DELETE  FROM clinic_ment WHERE  Name = '".$_COOKIE["USER"]."' ";
	$objQuery = mysql_query($strSQL);
	echo "<meta http-equiv ='refresh'content='0;URL=./clinicshow.php?clinic_id=".$_GET["clinic_id"]." '>";
}
?>
 
 



<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title> BeautyClinic  </title>
<!-- Linking styles -->
<link rel="stylesheet" href="css/screen.css" type="text/css" media="screen" title="default" />



<!-- Start ------ Select Zone Town Amphur -->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script type="text/javascript">
$(function(){
 	$("#town_id").change(function(){
	
		var url = "Select_town/amphur.php?town_id="+$(this).val() ;

		$.getJSON(
				url ,
				function(resp){
					var opt = "<option value='0'>-- อำเภอ --</option>";
					
					for(var i=0;i<resp.length;i++){
						opt += "<option value='"+ resp[i].amphur_id+"'>"+resp[i].amphur_name+"</option>";
					}
					$("#amphur_id").html( opt );
				} 
		);
	});
})
</script>

<script type="text/javascript">
$(function(){
 	$("#amphur_id").change(function(){
	
		var url = "Select_town/tambon.php?amphur_id="+$(this).val() ;

		$.getJSON(
				url ,
				function(resp){
					var opt = "<option value='0'>-- ตำบล --</option>";
					
					for(var i=0;i<resp.length;i++){
						opt += "<option value='"+ resp[i].tambon_id+"'>"+resp[i].tambon_name+"</option>";
					}	
					$("#tambon_id").html( opt );
				} 
		);
	});
})
</script>
<!-- End ------ Select Zone Town Amphur -->



<script type="text/javascript" src="js/jquery-1.6.1.min.js"></script>

<script type="text/javascript" src="jquery.rating.js"></script>
<link rel="stylesheet" media="screen" type="text/css" href="jquery.rating.css" />
<script type="text/javascript">
		$(document).ready(function(){
			//Turn all the select boxes into rating controls
		    $(".rating").rating();
		
			//Show that we can bind on the select box
			$("#serialStar2").bind("change", function(){
				$('#serialString2').text( $('#serialStar2').serialize() );
			});
			
			$("#serialStar").rating();
			
		});		
</script>



 

</head>




<body>

<?
//*** Select Question ***//
$strSQL = "SELECT * FROM clinic  WHERE clinic_id = '".$_GET["clinic_id"]."' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);

//*** Update View ***//
$strSQL = "UPDATE webboard ";
$strSQL .="SET View = View + 1 WHERE clinic_id = '".$_GET["clinic_id"]."' ";
$objQuery = mysql_query($strSQL);	
?>


<!-- Menu -->
    <header>
    <div class="marg">
        <div class="header">
 
	<!--  START Header -->
	<div id="Header">
			<!-- Start: page-top --> 	
			<div id="page-top"> </div>
			<!-- End: page-top -->
		<div class="clear">&nbsp;</div>
	</div>
	<!-- End: Header -->
	

<!--  START nav-outer-repeat -->
<div class="nav-outer-repeat"> 

<!--  ............................................................................ START main .............  -->
<div id ="main">

	<!--  start nav-outer -->
	<div class="nav-outer"> 

		<!-- start nav-right -->
		<div id="nav-right">	
				<? if(isset($_COOKIE["USER"]) == false){ ?>
					<div class="nav-divider-right">&nbsp;</div>

 					 <a href="./login.php"><img src="images/shared/login.png" alt="" /></a> 

					<div class="nav-divider-right">&nbsp;</div>

					 <a href="./signup.php"> <img src="images/shared/signup.png" alt="" /></a> 
		 
 					<div class="nav-divider-right">&nbsp;</div>
                <? } 
				
				else{ ?>
					<div id="member-form">
						<div class="nav-divider-right">&nbsp;</div>

  						<a href="./logout.php"> <img src="images/shared/logout.png" alt="" /> </a> 
	
  						<div class="nav-divider-right">&nbsp;</div>
	
 						<div class="member-bar-form"><a>  ยินดีต้อนรับ คุณ  <u>  <?=$_COOKIE["USER"]?>    </u>  </a>  </div>
				  
						 <div class="nav-divider-right">&nbsp;</div>
					</div>
            <? } ?>
 
				<div class="clear">&nbsp;</div>		 
		</div> <!--  END nav-right -->


		<!--  start nav left-->
		<div class="nav">
		<div class="table">
				<div class="nav-divider">&nbsp;</div>
				
				<ul class="select"><li> <a href="./index.php"> <b> หน้าหลัก </b> </a> </li></ul>
				<div class="nav-divider">&nbsp;</div>
								
				<ul class="select"><li> <a href="./clinic.php"> <b> ศูนย์ศัลยกรรม </b> </a> </li></ul>
				<div class="nav-divider">&nbsp;</div>
			
				<ul class="select"><li><a href="./doctor.php"> <b> ศัลยแพทย์ </b> </a> <!--[if lte IE 6]></td></tr></table></a><![endif]--> </li> </ul>
				<div class="nav-divider">&nbsp;</div>
			
				<ul class="select"><li><a href="#nogo"> <b> รีวิวการศัลยกรรม </b> </a> </li> </ul>
				<div class="nav-divider">&nbsp;</div>		
				
				<ul class="select"><li><a href="#nogo"> <b> ศัลย์วาไรตี้ </b> </a> </li> </ul>
				<div class="nav-divider">&nbsp;</div>
	 
				<div class="clear"></div>
		</div> <!--  END table -->

				<div class="clear"></div>	
		</div> <!--  END nav -->

</div>
<!--  ............. END main .............  -->

			<div class="clear"></div>
	</div> <!--  END nav-outer -->

</div>
<!--  END nav-outer-repeat -->





<!--  ..... start content-bg --- M A P ..... -->
<div id="content-bg">
  
</div>
<!--  ..... end content-bg --- M A P ..... -->

 
<!-- start page-bodyshow -- bg white -->
<div id="page-bodyshow">
 

<!-- START ........................................................................................................................ START MAIN-->
<div id ="main">
							
  
 

<!--  START -------------------------------------------------------------------------------------------------------------------------------------- left --> 
<div id="clinic_show_left">   <!--  START --- S e a r c h --- left --> 
 			<ul>
 				<img src="myfile/<?=$objResult["clinic_pic"];?>" class="img_clinic_show" />
 			</ul>

<!--  START --- S e a r c h --->
 	<div class="side_clinic_showleft">	 
 			<ul>
			<iframe width="100%" height="250" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.co.th/maps?q=%E0%B9%80%E0%B8%A1%E0%B8%B7%E0%B8%AD%E0%B8%87%E0%B9%80%E0%B8%8A%E0%B8%B5%E0%B8%A2%E0%B8%87%E0%B9%83%E0%B8%AB%E0%B8%A1%E0%B9%88+map&amp;ie=UTF8&amp;hl=th&amp;hq=&amp;hnear=%E0%B8%AD%E0%B8%B3%E0%B9%80%E0%B8%A0%E0%B8%AD%E0%B9%80%E0%B8%A1%E0%B8%B7%E0%B8%AD%E0%B8%87%E0%B9%80%E0%B8%8A%E0%B8%B5%E0%B8%A2%E0%B8%87%E0%B9%83%E0%B8%AB%E0%B8%A1%E0%B9%88+%E0%B8%88%E0%B8%B1%E0%B8%87%E0%B8%AB%E0%B8%A7%E0%B8%B1%E0%B8%94+%E0%B9%80%E0%B8%8A%E0%B8%B5%E0%B8%A2%E0%B8%87%E0%B9%83%E0%B8%AB%E0%B8%A1%E0%B9%88&amp;ll=18.787742,98.993108&amp;spn=0.006145,0.010568&amp;t=m&amp;z=14&amp;iwloc=A&amp;output=embed"></iframe><br /><small><a href="https://maps.google.co.th/maps?q=%E0%B9%80%E0%B8%A1%E0%B8%B7%E0%B8%AD%E0%B8%87%E0%B9%80%E0%B8%8A%E0%B8%B5%E0%B8%A2%E0%B8%87%E0%B9%83%E0%B8%AB%E0%B8%A1%E0%B9%88+map&amp;ie=UTF8&amp;hl=th&amp;hq=&amp;hnear=%E0%B8%AD%E0%B8%B3%E0%B9%80%E0%B8%A0%E0%B8%AD%E0%B9%80%E0%B8%A1%E0%B8%B7%E0%B8%AD%E0%B8%87%E0%B9%80%E0%B8%8A%E0%B8%B5%E0%B8%A2%E0%B8%87%E0%B9%83%E0%B8%AB%E0%B8%A1%E0%B9%88+%E0%B8%88%E0%B8%B1%E0%B8%87%E0%B8%AB%E0%B8%A7%E0%B8%B1%E0%B8%94+%E0%B9%80%E0%B8%8A%E0%B8%B5%E0%B8%A2%E0%B8%87%E0%B9%83%E0%B8%AB%E0%B8%A1%E0%B9%88&amp;ll=18.787742,98.993108&amp;spn=0.006145,0.010568&amp;t=m&amp;z=14&amp;iwloc=A&amp;source=embed" style="color:#0000FF;text-align:left">ดูแผนที่ขนาดใหญ่ขึ้น</a></small> 
  			</ul>
	 </div>		<!--  END --- S e a r c h --> 
 
  
 
<div id="clinic_show_left">   <!--  START --- S e a r c h --- left --> 
<!--  START --- S e a r c h --->
 	<div class="side_clinic_showleft">	 

<form id="form1" name="form1" method="post" action="">

		<table border="0" width="" cellpadding="0" cellspacing="0"  >
 								<tr><td>&nbsp;  </td></tr>
			<tr align="left"> <td width="18px"></td>
				<th valign="middle" colspan="3">Find on BeautyClinic </th>
			</tr>
			<tr valign="middle" >		<td width="18px"></td>					 
				<td colspan="3"> <input type="text" name="search" class="service"  placeholder=" ค้นหา ศูนย์ศัลยกรรม หรือ ศัลยแพทย์ ที่นี่ "     /> </td>
			</tr>
 
								<tr><td>&nbsp;  </td> <td>&nbsp;  </td> </tr>

			<tr align="left"> <td width="18px"></td>
				<th valign="middle" colspan="2" for="town_id">จังหวัด  </th>
			</tr>
 			<tr valign="middle" > <td width="18px"></td>
				<td>	
							<select name="town_id" id="town_id" class="service" >
									<option value="0">-- เลือกจังหวัด --</option>
								<?php while( $row_rs_town= mysql_fetch_assoc($rs_town) ) : ?>
									<option value="<?php echo $row_rs_town['town_id']?>"><?php echo $row_rs_town['town_name']?></option>
								<?php endwhile ;?>
							</select>
				</td>
			</tr>

								<tr><td>&nbsp;  </td></tr>

			<tr align="left"> <td width="18px"></td>
				<th valign="middle" colspan="2" for="amphur_id">อำเภอ  </th>
			</tr>
 			<tr valign="middle" >		<td></td>
				<td>	
							<select name="amphur_id" id="amphur_id" class="service" >
									<option value="0">-- เลือกอำเภอ --</option>
								<?php while( $row_rs_amphur = mysql_fetch_assoc($rs_amphur) ) : ?>
									<option value="<?php echo $row_rs_amphur['amphur_id']?>"><?php echo $row_rs_amphur['amphur_name']?></option>
								<?php endwhile ;?>
							</select>
				</td>
			</tr>

								<tr><td>&nbsp;  </td></tr>

			<tr align="left"> <td width="18px"></td>
				<th valign="middle" colspan="2" for="tambon_id">ตำบล </th>
			</tr>
 			<tr valign="middle" >		<td></td>
				<td>	
							<select name="tambon_id" id="tambon_id" class="service" >
									<option value="0">-- เลือกตำบล --</option>
							</select>
				</td>
			</tr>

								<tr><td>&nbsp;  </td></tr>

			<tr align="left"> <td width="18px"></td>
				<th valign="middle" colspan="2">ความประทับใจ (เฉลี่ย) : </th>
			</tr>
 			<tr valign="middle" >		<td></td>
				<td>	
					<select class="service" >
						<option value="">ทั้งหมด</option>
						<option value="">ความสะอาด สะดวกสบาย</option>
						<option value="">สถานที่ตั้ง</option>
						<option value="">การให้บริการ</option>
					</select>
				</td>
			</tr>
 								<tr><td>&nbsp;  </td></tr>
 			<tr>	<td colspan="4" align="center">  <input type="button" value=" ค้นหาข้อมูล " class="btn_search" />  </td>		<tr>
 								<tr><td>&nbsp;  </td></tr>
		</table>
</form>

	 </div>		<!--  END --- S e a r c h --> 
</div>
</div>		<!--  left  --> 
 <!--  End -------------------------------------------------------------------------------------------------------------------------------------- left --> 

<div id="clinic_show_right">    <!--  START --- C o n t e n t --- right -->
  
  <div class="side_clinic_show"> 	<!--  START --- Doctor SHOW -->	

 
<div class="sidebar_clinic_show">    <!--  start sidebar_clinic_show -->
 
	  <table border="0"   width="685px"> <tr> 
			<td width="560px">
			<ul>
 				<li> <h3>    <?=$objResult["clinic_name"];?>  </h3> </li>
  				<li> <img src="./images/shared/review/clinic.png">  ศูนย์ศัลยกรรม <?=$objResult["clinic_name"];?>    </li>
  				<li> ที่ตั้ง :   <?=$objResult["clinic_add"];?> ตำบล<?=$objResult["clinic_tambon"];?>  อำเภอ<?=$objResult["clinic_amphur"];?>   จังหวัด<?=$objResult["clinic_town"];?> <?=$objResult["clinic_post"];?>                       </li>
  				<li> เบอร์โทรศัพท์ :  <?=$objResult["clinic_tel"];?>    </li>
  				<li> เวลาเปิด-ปิดทำการ : <?=$objResult["clinic_open"];?> นาฬิกา   </li>
  				<li> เว็บไซต์ศูนย์ศัลยกรรมความงาม : <?=$objResult["clinic_website"];?>    </li>
			</ul>
		</td>
 
		<td align="right">
			<ul>
  				<li> vote : 4  </li>
				<li> &nbsp;  </li>	<li> &nbsp; </li> 
 			</ul>
		</td>
</tr> </table>
</div>	 <!--  end sidebar_clinic_show -->
     
 

<div class="side_clinic_shows">    <!--  start sidebar_clinic_shows -->
	<h4> ศัลยแพทย์ประจำศูนย์   </h4>
	<hr class="hr">
	
	<table border="0"> <tr> 
 			
<?
	$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
	$objDB = mysql_select_db("database");
	$strSQL3 = "SELECT * FROM doctor where clinic_name ='".$objResult["clinic_name"]."'   ";
	$objQuery3 = mysql_query($strSQL3) or die ("Error Query [".$strSQL."]");
?><?
while($objResult3 = mysql_fetch_array($objQuery3))
{  
	$c --;
?>	

	<td>
 			<ul>
				<a href="doctorshow.php?dr_id=<?=$objResult3["dr_id"];?>">  
  					<li> <img src="./images/img/contactus_00.jpg"   class="img_doctor_show_center" /> </li>
					 <li> <?=$objResult3["dr_name"];?>     </li>
				</a> 
			</ul>
  			 
   		 
 			 
	<?
if($c == 0) {
$c = $cols;
?>
	</td>
<tr></tr>
 <? }} ?>	
</tr>
 </table>  
 </div>	 <!--  end sidebar_clinic_show -->

 
<div class="sidebar_clinic_show_2">    <!--  start sidebar_clinic_show -->
 		 <table border="0"  >
  						<tr><td rowspan=16 width="16px"></td></tr>
 						<tr><td colspan=4 >  
							<table border="0" >
								<tr><td>&nbsp;  </td></tr>
 								<tr>
<td width="310px"> <input type="checkbox" name="chk1" <? echo (($objResult["chk1"] == "1")?"checked":""); ?> > เก็บถุงใต้ตา, แก้ร่องตาลึก			</td>  
<td width="330px"> <input type="checkbox" name="chk2" <? echo (($objResult["chk2"] == "1")?"checked":""); ?> > ทำตาสองชั้น			</td>  
<td width="320px"> <input type="checkbox" name="chk3" <? echo (($objResult["chk3"] == "1")?"checked":""); ?> > ตัดแต่งริมฝีปาก  			</td>  
								</tr>
								<tr><td>&nbsp;  </td></tr>
								<tr  valign="top">
<td>		<input type="checkbox" name="chk4" <? echo (($objResult["chk4"] == "1")?"checked":""); ?> > ตัดปีกจมูก   </td>  
<td>		<input type="checkbox" name="chk5" <? echo (($objResult["chk5"] == "1")?"checked":""); ?> > แก้ไขจมูก			</td>  
<td>		<input type="checkbox" name="chk6" <? echo (($objResult["chk6"] == "1")?"checked":""); ?>" > เสริมจมูก		</td>
								</tr>
								<tr><td>&nbsp;  </td></tr>
 								<tr  valign="top">
<td>		<input type="checkbox" name="chk7" <? echo (($objResult["chk7"] == "1")?"checked":""); ?> >  ทำลักยิ้ม			</td>  
<td>		<input type="checkbox" name="chk8" <? echo (($objResult["chk8"] == "1")?"checked":""); ?> >  สักคิ้ว 	 			</td>  
<td>		<input type="checkbox" name="chk9" <? echo (($objResult["chk9"] == "1")?"checked":""); ?> >  แก้หูกาง 	 			</td>  
 								</tr>
 								<tr><td>&nbsp;  </td></tr>
 								<tr  valign="top">
<td>		<input type="checkbox" name="chk10" <? echo (($objResult["chk10"] == "1")?"checked":""); ?> >	 ปลูกผม	 </td>  
<td>		<input type="checkbox" name="chk11" <? echo (($objResult["chk11"] == "1")?"checked":""); ?> >	 ตกแต่งแผลเป็น	 	</td>  
<td>		<input type="checkbox" name="chk12" <? echo (($objResult["chk12"] == "1")?"checked":""); ?> >  ร้อยไหม 	</td> 
 								</tr>
 								<tr><td>&nbsp;  </td></tr>
 								<tr  valign="top">
<td>		<input type="checkbox" name="chk13" <? echo (($objResult["chk13"] == "1")?"checked":""); ?> > ดึงหน้า  </td>  
<td>		<input type="checkbox" name="chk14" <? echo (($objResult["chk14"] == "1")?"checked":""); ?> > ดึงหางหงษ์			</td>  
<td>		<input type="checkbox" name="chk15" <? echo (($objResult["chk15"] == "1")?"checked":""); ?> >  ดึงหน้าผาก ดึงคิ้ว แก้คิ้วตก ลดรอยย่น		</td>  
 								</tr>
 								<tr><td>&nbsp;  </td></tr>
 								<tr  valign="top">
<td>		<input type="checkbox" name="chk16" <? echo (($objResult["chk16"] == "1")?"checked":""); ?> > ดึงคอ แก้เหนียงคอย้อย 			</td>  
<td>		<input type="checkbox" name="chk17" <? echo (($objResult["chk17"] == "1")?"checked":""); ?> > เสริม-ลด คาง กราม โหนกแก้ม หน้าผาก		</td>  
<td>		<input type="checkbox" name="chk18" <? echo (($objResult["chk18"] == "1")?"checked":""); ?> > เสริม-ลด ก้น				</td>  
								</tr>
 								<tr><td>&nbsp;  </td></tr>
 								<tr  valign="top">
<td>	<input type="checkbox" name="chk19" <? echo (($objResult["chk19"] == "1")?"checked":""); ?> > เสริม, ลด ขนาดหน้าอก			</td>  
<td>	<input type="checkbox" name="chk20" <? echo (($objResult["chk20"] == "1")?"checked":""); ?> > ลดขนาดหัวนมและปานนม		</td>  
<td>	<input type="checkbox" name="chk21" <? echo (($objResult["chk21"] == "1")?"checked":""); ?> >  กระชับผิวหนัง ลดการแตกลาย แก้ผิวหนังย่น			</td> 
 								</tr>
 								<tr><td>&nbsp;  </td></tr>
 								<tr  valign="top">
<td>	<input type="checkbox" name="chk22" <? echo (($objResult["chk22"] == "1")?"checked":""); ?> >  ดูดไขมัน		</td>  
<td>	<input type="checkbox" name="chk23" <? echo (($objResult["chk23"] == "1")?"checked":""); ?> >  เติม  Graft ไขมันเพื่อเสริมอวัยวะ 				</td>  
<td>	<input type="checkbox" name="chk24" <? echo (($objResult["chk24"] == "1")?"checked":""); ?> >  แก้ผิวขรุขระจากการดูดไขมันมาก่อน   	</td> 
 								</tr>
 								<tr><td>&nbsp;  </td></tr>
 								<tr  valign="top">
<td>	<input type="checkbox" name="chk25" <? echo (($objResult["chk25"] == "1")?"checked":""); ?> >  ผ่าตัดกระดูกใบหน้าและศรีษะ สามมิติ  </td>  
<td>	<input type="checkbox" name="chk26" <? echo (($objResult["chk26"] == "1")?"checked":""); ?> >  ฉีด Fillers	</td>  
<td>	<input type="checkbox" name="chk27" <? echo (($objResult["chk27"] == "1")?"checked":""); ?> >  ฉีด Botox	 </h5>	</td>  
 								</tr>
  							</table>
						</td><td rowspan=16 width="10px"></td></tr>
						<tr><td>&nbsp;  </td></tr>
 		</table>
 </div>	 <!--  end sidebar_clinic_show -->
 


<div class="sidebar_clinic_show_2">    <!--  start sidebar_clinic_show -->
 		 <table border="0"  >

 						<tr><td rowspan=16 width="16px"></td></tr>
 						<tr><td colspan=4 >  
							<table border="0"  class="table-checkbox"  >
								<tr><td>&nbsp;  </td></tr>
								<tr>
									<td width="290px">		<input type="checkbox" name="chk28" value="28" > ห้องพักฟื้น			</td>  
									<td width="295px">		<input type="checkbox" name="chk29" value="29" > ฟรี WiFi			</td>  
									<td width="295px">		<input type="checkbox" name="chk30" value="30" > ที่จอดรถ  			</td>  
									</tr>
								<tr><td>&nbsp;  </td></tr>
								<tr  valign="middle"  >
									<td colspan=3> <input type="checkbox" name="checkbox" <? echo (($objResult["chk31"] != "")?"checked":""); ?> > 	 
										<a type="text" name="chk31"  class="c-dr-reg_member" value="<? echo ($objResult["chk31"] != ""); ?>"  />  </td>
								</tr>
							</table>
						</td><td rowspan=16 width="10px"></td></tr>
						<tr><td>&nbsp;  </td></tr>
 		</table>
 </div>	 <!--  end sidebar_clinic_show -->


<div class="sidebar_clinic_show_2">    <!--  start sidebar_clinic_show -->
 		 <table border="0"  >
 						<tr><td rowspan=16 width="16px"></td></tr>
 						<tr><td colspan=4 >  
							<table border="0"  class="table-checkbox"  name="chk28">  
								<tr><td>&nbsp;    </td></tr>
								<tr>
									<td>	รายละเอียด	  <?=nl2br($objResult["Details"]);?>	</td>  
 								</tr>
  							</table>
						</td><td rowspan=16 width="10px"></td></tr>
						<tr><td>&nbsp;  </td></tr>
 		</table>
 </div>	 <!--  end sidebar_clinic_show -->
 
<?
	$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
	$objDB = mysql_select_db("database");
	$strSQL = "SELECT * FROM files where Name='".$objResult["clinic_name"]."'";
	$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>

<div class="sidebar_clinic_show">    <!--  start sidebar_clinic_show -->
	<h4> รูปภาพศูนย์ศัลยกรรมความงาม </h4>
	<hr class="hr">
	  <table border="0" width="710px"> <tr> 
			<td >
	<?
	while($objResult = mysql_fetch_array($objQuery))
	{
?>		<ul>
   				<li> <img src="myfile/<?=$objResult["FilesName"];?>" class="img_clinic_show2" /> </li>
 			</ul>
<?
	}
?>		</td>
	 </tr> </table>
 </div>	 <!--  end sidebar_clinic_show -->
 








<div class="sidebar_clinic_show">    <!--  start sidebar_clinic_show -->
	<h4> ความพึงพอใจของลูกค้า </h4>
	<hr class="hr"> 
<form name="form1" method="post" action="clinicshow.php">
<table border=1>
<tr><td width="220px">คุ้มค่ากับเงินที่จ่าย  </td><td>
	<select name="myRating" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td> <td width="20px" align="right"><?  echo $myRating;  ?>  </td></tr>

<tr><td>สภาพแวดล้อม, ความสะอาด </td><td>
	<select name="myRating2" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td> <td align="right"><?  echo $myRating2;  ?>  </td></tr>

<tr><td>การให้บริการของพนักงาน  </td><td>
	<select name="myRating3" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td> <td align="right"><?  echo $myRating3;  ?>  </td></tr>

<tr><td>สถานที่ตั้ง, สะดวกต่อการเดินทาง  </td><td>
	<select name="myRating4" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td> <td align="right"><?  echo $myRating4;  ?>  </td></tr>
 </table>

<button onClick="$('#seralString').text( $('#serialStar').val() );">Serialize</button>
 
  <input type="submit" name="submittest" id="submittest" value="Submit">
</form>
 </div>	 <!--  end sidebar_clinic_show -->













<div class="sidebar_clinic_show">    <!--  start sidebar_clinic_show -->
 <? if(isset($_COOKIE["USER"]) == false){ ?> 
<? } 
else{ $intRows++; ?> 
	<form action="clinicshow.php?clinic_id=<?=$_GET["clinic_id"];?>&Action=Save" method="post" name="frmMain" id="frmMain"> 
 
 	</form>
<? } ?>

 </div>	 <!--  end sidebar_clinic_show -->


<div class="sidebar_clinic_show">    <!--  start sidebar_clinic_show -->
	<h4> การแสดงความคิดเห็น   </h4>
	<hr class="hr">
<? if(isset($_COOKIE["USER"]) == false){ ?> 
<? } 
else{ $intRows++; ?> 
	<form action="clinicshow.php?clinic_id=<?=$_GET["clinic_id"];?>&Action=Save" method="post" name="frmMain" id="frmMain"> 
 	
<table border=0 >
<tr><td> &nbsp;</td></tr>
<tr valign="top"><td colspan=2 height="20px"><h5> ::: โหวตคะแนนความพึงพอใจ :::</h5></td>  <td rowspan='5' valign="top"><textarea  class="comment" name="txtDetails"></textarea></tr>
<tr valign="top"><td width="200px"> คุ้มค่ากับเงินที่จ่าย  </td><td>
	<select name="myRating" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td>  </tr>

<tr valign="top"><td> สภาพแวดล้อม, ความสะอาด </td><td>
	<select name="myRating2" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td>  </tr>

<tr valign="top"><td> การให้บริการของพนักงาน  </td><td>
	<select name="myRating3" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td> </tr>

<tr valign="top"><td> สถานที่ตั้ง, สะดวกต่อการเดินทาง  </td><td>
	<select name="myRating4" class="rating"  id="serialStar">
		<option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option>
	</select>  
</td>   </tr>
 </table>
 		<p> <table border="0">
 			<tr> 
				<td align="right" width="660px">  คุณ  <?=$_COOKIE["USER"]?><input type="hidden" name="name" value="<?=$_COOKIE["USER"]?>" size="32">    </td> 
				<td align="right"> 
			    <input type="submit" id="form-submit" class="awesome orange medium"  value="ตกลง" />   
				</td>
			</tr>
		</table>  </p>   
	</form>

 	<hr class="hr">
<? } ?>

<?
$intRows = 0;
$strSQL2 = "SELECT * FROM clinic_ment WHERE clinic_id = '".$_GET["clinic_id"]."' ";
$objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL."]");
while($objResult2 = mysql_fetch_array($objQuery2))
{  
?>    
<a href="clinicshow.php?clinic_id=<?=$_GET["clinic_id"];?>&Action=Delete"></a>
 <form action="clinicshow.php?clinic_id=<?=$_GET["clinic_id"];?>&Action=Delete" method="post" name="frmMain" id="frmMain"> 
 	<div class="clinic_show_under">    <!--  start sidebar_clinic_show -->
		<table border="0" width="680px">
			<tr valign="top"> 
				<td align="left" width="160px">  คุณ  <?=$objResult2["Name"];?>  <br><br>  วันที่ <?=$objResult2["CreateDate"];?> 
						<br>  เวลา <?=$objResult2["Time"];?> </td> 
				<td width="20px">&nbsp; </td>
			<td>
								<?=nl2br($objResult2["Details"]);?>
			</td>
  			</tr>
		</table>

	</div>	 <!--  end clinic_show_under -->
</form>
<?
}
?>
 


 </div>	 <!--  end sidebar_clinic_show -->




 
 		
</div>   <!--  End --- Doctor SHOW -->	

</div>   <!--  End --- right -->	
</div> 

  
 


<div class="clear">&nbsp;</div>
    
<!-- start footer -->         
<div id="footer">
<!-- <div id="footer-pad">&nbsp;</div> -->
	<!--  start footer-left -->
	<div id="footer-left"> Contact : beautyclinic@info	
	  <a href="">BeautyClinic &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>.</div>
	<!--  end footer-left -->
	<div class="clear">&nbsp;</div>
</div>
<!-- end footer -->


</div>
<!--  end page-bodyshow -->

 

 </div>
<!-- END   ........................................................................................................................ END MAIN -->

 



</body>
</html>
 
<?
mysql_close($objConnect);
?>


 